2025-11-13 09:44:24,672 [ 367415 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse (runner:53, check_args_and_update_paths) 2025-11-13 09:44:24,673 [ 367415 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:79, check_args_and_update_paths) 2025-11-13 09:44:24,673 [ 367415 ] INFO : utils dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/utils (runner:90, check_args_and_update_paths) 2025-11-13 09:44:24,673 [ 367415 ] INFO : base_configs_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:92, check_args_and_update_paths) clickhouse_integration_tests_volume Running pytest container as: 'docker run --rm --name clickhouse_integration_tests_0dywgn --privileged --dns-search='.' --memory=30709039104 --security-opt seccomp=unconfined --cap-add=SYS_PTRACE --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=5dc43a6382f0 -e DOCKER_BASE_TAG=5ccda723c1fc -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=d862517635bf -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 --report-log=parallel3_0.jsonl --report-log-exclude-logs-on-passed-tests test_storage_nats/test.py::test_nats_virtual_column_with_materialized_view test_storage_nats/test.py::test_row_based_formats test_storage_url_with_proxy/test.py::test_s3_with_proxy_list test_store_cleanup/test.py::test_store_cleanup test_system_clusters_actual_information/test.py::test test_table_function_mongodb/test.py::test_auth_source test_table_function_mongodb/test.py::test_complex_data_type test_table_function_mongodb/test.py::test_incorrect_data_type test_table_function_mongodb/test.py::test_missing_columns test_table_function_mongodb/test.py::test_no_credentials test_table_function_mongodb/test.py::test_oid test_table_function_mongodb/test.py::test_secure_connection test_table_function_mongodb/test.py::test_secure_connection_uri test_table_function_mongodb/test.py::test_secure_connection_with_validation test_table_function_mongodb/test.py::test_simple_select test_table_function_mongodb/test.py::test_simple_select_uri test_truncate_database/test_replicated.py::test_truncate_database_replicated test_unambiguous_alter_commands/test.py::test_alter test_unambiguous_alter_commands/test.py::test_move_partition_to_table_command test_user_grants_from_config/test.py::test_allow_read_from_system_tables test_user_grants_from_config/test.py::test_role_grants_from_config test_user_grants_from_config/test.py::test_user_grants_from_config test_userspace_page_cache/test.py::test_basics test_userspace_page_cache/test.py::test_size_adjustment test_wrong_db_or_table_name/test.py::test_database_engine_name test_wrong_db_or_table_name/test.py::test_drop_wrong_database_name test_wrong_db_or_table_name/test.py::test_drop_wrong_table_name test_wrong_db_or_table_name/test.py::test_wrong_database_name test_wrong_db_or_table_name/test.py::test_wrong_table_name -vvv " altinityinfra/integration-tests-runner:226bfaf75ac1 '. Start tests ============================= test session starts ============================== platform linux -- Python 3.10.12, pytest-7.4.4, pluggy-1.5.0 -- /usr/bin/python3 cachedir: .pytest_cache Test order randomisation NOT enabled. Enable with --random-order or --random-order-bucket= rootdir: /ClickHouse/tests/integration configfile: pytest.ini plugins: timeout-2.3.1, repeat-0.9.3, order-1.0.0, reportlog-0.4.0, xdist-3.5.0, random-order-1.1.1 timeout: 900.0s timeout method: signal timeout func_only: False created: 10/10 workers 10 workers [29 items] scheduling tests via LoadFileScheduling test_storage_url_with_proxy/test.py::test_s3_with_proxy_list test_wrong_db_or_table_name/test.py::test_database_engine_name test_table_function_mongodb/test.py::test_auth_source test_store_cleanup/test.py::test_store_cleanup test_truncate_database/test_replicated.py::test_truncate_database_replicated test_unambiguous_alter_commands/test.py::test_alter test_userspace_page_cache/test.py::test_basics test_storage_nats/test.py::test_nats_virtual_column_with_materialized_view test_user_grants_from_config/test.py::test_allow_read_from_system_tables test_system_clusters_actual_information/test.py::test [gw7] [ 3%] PASSED test_unambiguous_alter_commands/test.py::test_alter test_unambiguous_alter_commands/test.py::test_move_partition_to_table_command [gw7] [ 6%] PASSED test_unambiguous_alter_commands/test.py::test_move_partition_to_table_command [gw1] [ 10%] PASSED test_user_grants_from_config/test.py::test_allow_read_from_system_tables test_user_grants_from_config/test.py::test_role_grants_from_config [gw1] [ 13%] PASSED test_user_grants_from_config/test.py::test_role_grants_from_config test_user_grants_from_config/test.py::test_user_grants_from_config [gw1] [ 17%] PASSED test_user_grants_from_config/test.py::test_user_grants_from_config [gw0] [ 20%] PASSED test_wrong_db_or_table_name/test.py::test_database_engine_name test_wrong_db_or_table_name/test.py::test_drop_wrong_database_name [gw0] [ 24%] PASSED test_wrong_db_or_table_name/test.py::test_drop_wrong_database_name test_wrong_db_or_table_name/test.py::test_drop_wrong_table_name [gw5] [ 27%] PASSED test_storage_url_with_proxy/test.py::test_s3_with_proxy_list [gw3] [ 31%] PASSED test_storage_nats/test.py::test_nats_virtual_column_with_materialized_view [gw0] [ 34%] PASSED test_wrong_db_or_table_name/test.py::test_drop_wrong_table_name test_wrong_db_or_table_name/test.py::test_wrong_database_name test_storage_nats/test.py::test_row_based_formats [gw0] [ 37%] PASSED test_wrong_db_or_table_name/test.py::test_wrong_database_name test_wrong_db_or_table_name/test.py::test_wrong_table_name [gw0] [ 41%] PASSED test_wrong_db_or_table_name/test.py::test_wrong_table_name [gw9] [ 44%] PASSED test_truncate_database/test_replicated.py::test_truncate_database_replicated [gw4] [ 48%] PASSED test_userspace_page_cache/test.py::test_basics test_userspace_page_cache/test.py::test_size_adjustment [gw4] [ 51%] SKIPPED test_userspace_page_cache/test.py::test_size_adjustment [gw2] [ 55%] PASSED test_table_function_mongodb/test.py::test_auth_source test_table_function_mongodb/test.py::test_complex_data_type [gw2] [ 58%] PASSED test_table_function_mongodb/test.py::test_complex_data_type test_table_function_mongodb/test.py::test_incorrect_data_type [gw2] [ 62%] PASSED test_table_function_mongodb/test.py::test_incorrect_data_type test_table_function_mongodb/test.py::test_missing_columns [gw2] [ 65%] PASSED test_table_function_mongodb/test.py::test_missing_columns test_table_function_mongodb/test.py::test_no_credentials [gw2] [ 68%] PASSED test_table_function_mongodb/test.py::test_no_credentials test_table_function_mongodb/test.py::test_oid [gw2] [ 72%] PASSED test_table_function_mongodb/test.py::test_oid test_table_function_mongodb/test.py::test_secure_connection [gw2] [ 75%] PASSED test_table_function_mongodb/test.py::test_secure_connection test_table_function_mongodb/test.py::test_secure_connection_uri [gw2] [ 79%] PASSED test_table_function_mongodb/test.py::test_secure_connection_uri test_table_function_mongodb/test.py::test_secure_connection_with_validation [gw2] [ 82%] PASSED test_table_function_mongodb/test.py::test_secure_connection_with_validation test_table_function_mongodb/test.py::test_simple_select [gw2] [ 86%] PASSED test_table_function_mongodb/test.py::test_simple_select test_table_function_mongodb/test.py::test_simple_select_uri [gw2] [ 89%] PASSED test_table_function_mongodb/test.py::test_simple_select_uri [gw3] [ 93%] PASSED test_storage_nats/test.py::test_row_based_formats [gw6] [ 96%] PASSED test_store_cleanup/test.py::test_store_cleanup [gw8] [100%] PASSED test_system_clusters_actual_information/test.py::test =============================== warnings summary =============================== test_table_function_mongodb/test.py::test_auth_source /ClickHouse/tests/integration/test_table_function_mongodb/test.py:368: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead admin_db.add_user( test_table_function_mongodb/test.py::test_complex_data_type /ClickHouse/tests/integration/test_table_function_mongodb/test.py:125: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", mongo_pass) test_table_function_mongodb/test.py::test_complex_data_type test_table_function_mongodb/test.py::test_secure_connection /usr/local/lib/python3.10/dist-packages/pymongo/database.py:1247: DeprecationWarning: Creating a user with the read_only option or without roles is deprecated in MongoDB >= 2.6 warnings.warn("Creating a user with the read_only option " test_table_function_mongodb/test.py::test_incorrect_data_type /ClickHouse/tests/integration/test_table_function_mongodb/test.py:182: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", mongo_pass) test_table_function_mongodb/test.py::test_missing_columns /ClickHouse/tests/integration/test_table_function_mongodb/test.py:404: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", mongo_pass) test_table_function_mongodb/test.py::test_secure_connection /ClickHouse/tests/integration/test_table_function_mongodb/test.py:202: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", mongo_pass) test_table_function_mongodb/test.py::test_secure_connection_uri /ClickHouse/tests/integration/test_table_function_mongodb/test.py:296: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", mongo_pass) test_table_function_mongodb/test.py::test_secure_connection_with_validation /ClickHouse/tests/integration/test_table_function_mongodb/test.py:271: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", mongo_pass) test_table_function_mongodb/test.py::test_simple_select /ClickHouse/tests/integration/test_table_function_mongodb/test.py:47: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", mongo_pass) test_table_function_mongodb/test.py::test_simple_select_uri /ClickHouse/tests/integration/test_table_function_mongodb/test.py:86: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", mongo_pass) -- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html ----------------- generated report log file: parallel3_0.jsonl ----------------- ============================== slowest durations =============================== 120.39s call test_system_clusters_actual_information/test.py::test 72.05s call test_store_cleanup/test.py::test_store_cleanup 46.32s call test_storage_nats/test.py::test_row_based_formats 32.22s setup test_table_function_mongodb/test.py::test_auth_source 22.63s setup test_system_clusters_actual_information/test.py::test 21.78s teardown test_userspace_page_cache/test.py::test_size_adjustment 21.68s teardown test_storage_url_with_proxy/test.py::test_s3_with_proxy_list 20.86s setup test_truncate_database/test_replicated.py::test_truncate_database_replicated 17.68s setup test_userspace_page_cache/test.py::test_basics 17.25s setup test_storage_url_with_proxy/test.py::test_s3_with_proxy_list 16.63s setup test_storage_nats/test.py::test_nats_virtual_column_with_materialized_view 15.32s setup test_wrong_db_or_table_name/test.py::test_database_engine_name 14.73s setup test_user_grants_from_config/test.py::test_allow_read_from_system_tables 14.22s setup test_store_cleanup/test.py::test_store_cleanup 14.09s setup test_unambiguous_alter_commands/test.py::test_alter 11.30s call test_userspace_page_cache/test.py::test_basics 9.05s call test_table_function_mongodb/test.py::test_oid 8.30s teardown test_system_clusters_actual_information/test.py::test 6.25s teardown test_storage_nats/test.py::test_row_based_formats 5.22s teardown test_truncate_database/test_replicated.py::test_truncate_database_replicated 4.30s teardown test_unambiguous_alter_commands/test.py::test_move_partition_to_table_command 4.07s teardown test_user_grants_from_config/test.py::test_user_grants_from_config 3.88s call test_truncate_database/test_replicated.py::test_truncate_database_replicated 3.69s teardown test_table_function_mongodb/test.py::test_simple_select_uri 3.14s teardown test_wrong_db_or_table_name/test.py::test_wrong_table_name 2.70s call test_storage_nats/test.py::test_nats_virtual_column_with_materialized_view 1.88s call test_wrong_db_or_table_name/test.py::test_drop_wrong_table_name 1.84s call test_table_function_mongodb/test.py::test_simple_select 1.63s call test_wrong_db_or_table_name/test.py::test_wrong_table_name 1.62s call test_table_function_mongodb/test.py::test_secure_connection 1.61s call test_table_function_mongodb/test.py::test_secure_connection_uri 1.44s call test_table_function_mongodb/test.py::test_simple_select_uri 1.20s call test_table_function_mongodb/test.py::test_complex_data_type 1.18s call test_wrong_db_or_table_name/test.py::test_wrong_database_name 1.17s call test_wrong_db_or_table_name/test.py::test_drop_wrong_database_name 1.12s call test_wrong_db_or_table_name/test.py::test_database_engine_name 1.08s teardown test_store_cleanup/test.py::test_store_cleanup 1.02s call test_table_function_mongodb/test.py::test_auth_source 0.74s call test_storage_url_with_proxy/test.py::test_s3_with_proxy_list 0.68s call test_user_grants_from_config/test.py::test_allow_read_from_system_tables 0.58s call test_table_function_mongodb/test.py::test_missing_columns 0.57s call test_unambiguous_alter_commands/test.py::test_alter 0.53s call test_user_grants_from_config/test.py::test_user_grants_from_config 0.52s call test_unambiguous_alter_commands/test.py::test_move_partition_to_table_command 0.44s call test_table_function_mongodb/test.py::test_incorrect_data_type 0.43s setup test_storage_nats/test.py::test_row_based_formats 0.35s call test_table_function_mongodb/test.py::test_secure_connection_with_validation 0.34s call test_table_function_mongodb/test.py::test_no_credentials 0.32s call test_userspace_page_cache/test.py::test_size_adjustment 0.27s teardown test_storage_nats/test.py::test_nats_virtual_column_with_materialized_view 0.22s call test_user_grants_from_config/test.py::test_role_grants_from_config 0.00s setup test_table_function_mongodb/test.py::test_secure_connection_with_validation 0.00s setup test_table_function_mongodb/test.py::test_no_credentials 0.00s teardown test_table_function_mongodb/test.py::test_auth_source 0.00s setup test_wrong_db_or_table_name/test.py::test_drop_wrong_table_name 0.00s setup test_table_function_mongodb/test.py::test_complex_data_type 0.00s setup test_user_grants_from_config/test.py::test_role_grants_from_config 0.00s teardown test_wrong_db_or_table_name/test.py::test_database_engine_name 0.00s setup test_table_function_mongodb/test.py::test_incorrect_data_type 0.00s setup test_table_function_mongodb/test.py::test_simple_select 0.00s teardown test_userspace_page_cache/test.py::test_basics 0.00s setup test_table_function_mongodb/test.py::test_simple_select_uri 0.00s setup test_table_function_mongodb/test.py::test_missing_columns 0.00s setup test_table_function_mongodb/test.py::test_secure_connection_uri 0.00s setup test_table_function_mongodb/test.py::test_secure_connection 0.00s setup test_table_function_mongodb/test.py::test_oid 0.00s setup test_wrong_db_or_table_name/test.py::test_drop_wrong_database_name 0.00s teardown test_table_function_mongodb/test.py::test_secure_connection_uri 0.00s teardown test_table_function_mongodb/test.py::test_missing_columns 0.00s setup test_userspace_page_cache/test.py::test_size_adjustment 0.00s setup test_wrong_db_or_table_name/test.py::test_wrong_table_name 0.00s setup test_wrong_db_or_table_name/test.py::test_wrong_database_name 0.00s teardown test_table_function_mongodb/test.py::test_incorrect_data_type 0.00s teardown test_user_grants_from_config/test.py::test_allow_read_from_system_tables 0.00s teardown test_table_function_mongodb/test.py::test_complex_data_type 0.00s teardown test_table_function_mongodb/test.py::test_oid 0.00s teardown test_table_function_mongodb/test.py::test_simple_select 0.00s teardown test_wrong_db_or_table_name/test.py::test_drop_wrong_database_name 0.00s teardown test_table_function_mongodb/test.py::test_secure_connection 0.00s teardown test_wrong_db_or_table_name/test.py::test_wrong_database_name 0.00s teardown test_table_function_mongodb/test.py::test_secure_connection_with_validation 0.00s teardown test_table_function_mongodb/test.py::test_no_credentials 0.00s teardown test_wrong_db_or_table_name/test.py::test_drop_wrong_table_name 0.00s setup test_unambiguous_alter_commands/test.py::test_move_partition_to_table_command 0.00s setup test_user_grants_from_config/test.py::test_user_grants_from_config 0.00s teardown test_unambiguous_alter_commands/test.py::test_alter 0.00s teardown test_user_grants_from_config/test.py::test_role_grants_from_config =========================== short test summary info ============================ PASSED test_unambiguous_alter_commands/test.py::test_alter PASSED test_unambiguous_alter_commands/test.py::test_move_partition_to_table_command PASSED test_user_grants_from_config/test.py::test_allow_read_from_system_tables PASSED test_user_grants_from_config/test.py::test_role_grants_from_config PASSED test_user_grants_from_config/test.py::test_user_grants_from_config PASSED test_wrong_db_or_table_name/test.py::test_database_engine_name PASSED test_wrong_db_or_table_name/test.py::test_drop_wrong_database_name PASSED test_storage_url_with_proxy/test.py::test_s3_with_proxy_list PASSED test_storage_nats/test.py::test_nats_virtual_column_with_materialized_view PASSED test_wrong_db_or_table_name/test.py::test_drop_wrong_table_name PASSED test_wrong_db_or_table_name/test.py::test_wrong_database_name PASSED test_wrong_db_or_table_name/test.py::test_wrong_table_name PASSED test_truncate_database/test_replicated.py::test_truncate_database_replicated PASSED test_userspace_page_cache/test.py::test_basics PASSED test_table_function_mongodb/test.py::test_auth_source PASSED test_table_function_mongodb/test.py::test_complex_data_type PASSED test_table_function_mongodb/test.py::test_incorrect_data_type PASSED test_table_function_mongodb/test.py::test_missing_columns PASSED test_table_function_mongodb/test.py::test_no_credentials PASSED test_table_function_mongodb/test.py::test_oid PASSED test_table_function_mongodb/test.py::test_secure_connection PASSED test_table_function_mongodb/test.py::test_secure_connection_uri PASSED test_table_function_mongodb/test.py::test_secure_connection_with_validation PASSED test_table_function_mongodb/test.py::test_simple_select PASSED test_table_function_mongodb/test.py::test_simple_select_uri PASSED test_storage_nats/test.py::test_row_based_formats PASSED test_store_cleanup/test.py::test_store_cleanup PASSED test_system_clusters_actual_information/test.py::test SKIPPED [1] test_userspace_page_cache/test.py:163: sanitizer build has higher memory consumption; also it is slow ============ 28 passed, 1 skipped, 11 warnings in 153.15s (0:02:33) ============